SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 42263: A SAS® Marketing Optimization group might return the error "Missing column detected in Historic_communications table" and fail to run

DetailsAboutRate It

The SAS Marketing Optimization group fails to run with the following error if you are using contact history and mandatory inclusions together:

Missing column detected in Historic_communications table

This problem occurs only when you create contact policies that have communication filters using the MANDATORY, EXCLUDE_FROM_CONSTRAINTS, or EXCLUDE_FROM_CONTACT_POLS columns. Most contact policy filters are on channel or campaign code.

The workaround is to either use either contact history or mandatory inclusions, but not both.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Marketing OptimizationMicrosoft® Windows® for x645.46.19.2 TS2M39.3 TS1M0
64-bit Enabled AIX5.46.19.2 TS2M39.3 TS1M0
64-bit Enabled HP-UX5.46.19.2 TS2M39.3 TS1M0
64-bit Enabled Solaris5.46.19.2 TS2M39.3 TS1M0
HP-UX IPF5.46.19.2 TS2M39.3 TS1M0
Linux for x645.46.19.2 TS2M39.3 TS1M0
Solaris for x645.46.19.2 TS2M39.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.